package com.dq.utils.file;

import cn.hutool.core.io.FileUtil;
import cn.hutool.poi.excel.ExcelReader;
import cn.hutool.poi.excel.ExcelUtil;

import java.util.List;
import java.util.Map;

/**
 * @author cf
 */
public class ExcelAllUtils {

    public static void main(String[] args) {
        ExcelReader reader = ExcelUtil.getReader(FileUtil.file("C:\\Users\\Administrator\\Desktop\\盘点表.xls"));
        List<List<Object>> readAll = reader.read();
        for (int i = 3; i < readAll.size(); i++) {
            List<Object> objects = readAll.get(i);
            String categoryName = objects.get(1).toString();
            String goodsCardNo = objects.get(2).toString();
            String goodsName = objects.get(3).toString();
            String goodsStock = objects.get(8).toString();

        }
    }

}
